package com.ai.mapper.provider;


import org.apache.ibatis.jdbc.SQL;

public class JobProvider {
    public String getJobListSQl(){
        return new SQL(){{
            SELECT("j.id as id,j.job_name as jobName,j.job_desc as jobDesc,j.status as status,i.ai_name as interviewerName,i.id as interviewerId, j.prompt as prompt,j.create_time as createTime,j.updated_time as updatedTime");
            FROM("job j left JOIN interviewer i on j.interviewer_id = i.id");
//            ORDER_BY("j.create_time  DESC");
        }}.toString()+" ";
    }
}
